SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Sheets to PDF pages

Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

XLThumbview.zip

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

GetTempFileName

Returns temp file name using FSO

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...